UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZG/U8EHRChGgnUm2AH6DYNszO5v7kqlDHsV8cG4Q20Y='
WHERE
key_id = '6bf6f589d1e64d86249813f770393065fdda52064b497f1e3e3b17a112536508'
AND (
token = 'ZG/U8EHRChGgnUm2AH6DYNszO5v7kqlDHsV8cG4Q20Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)