UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8KEs+mW2XI66LwkNwwZb8noJj68k8JjTiJitK20WRM='
WHERE
key_id = '7b954ede6584a5b38712a666ac14c18f3d24ae78914130c4e66fe10ed3c03573'
AND (
token = 'X8KEs+mW2XI66LwkNwwZb8noJj68k8JjTiJitK20WRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)