UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NBn9kTj13xM7RWDmc+b55cXRQswG0+cNvmqlP6+r/n8='
WHERE
key_id = '52775a029fe1cb2c89a16e9bdda46a0dbc7528289c98c4f3ea4bb99939618599'
AND (
token = 'NBn9kTj13xM7RWDmc+b55cXRQswG0+cNvmqlP6+r/n8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)