UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jOn0OvETVEz6U5iN11/YvWau3D/17us19J+feV6YMYU='
WHERE
key_id = '5a6f24561655aa39f7ab0b35947170736a6da47e88e07d56353258a7eee6375f'
AND (
token = 'jOn0OvETVEz6U5iN11/YvWau3D/17us19J+feV6YMYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)