UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zEzfP9FjALZJNqGhPZjt1IIo3qY0GCpbxVoRECc08x0='
WHERE
key_id = '06a02970847956f74a69a0177ada3822c744fc21677c6486028b31b4a0a7c3d3'
AND (
token = 'zEzfP9FjALZJNqGhPZjt1IIo3qY0GCpbxVoRECc08x0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)