UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xdMZ4xwSZZAOxi7SYQfKvYISCndBSMTMxMGqc4T0quY='
WHERE
key_id = 'e4745acb1c97db7b80d53c8e2839a3f347ebcfcd855c26c34706f5df608ace27'
AND (
token = 'xdMZ4xwSZZAOxi7SYQfKvYISCndBSMTMxMGqc4T0quY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)