UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lWRnOd7STlgDtFTjAB82PgOQdz8fdSwoefm2xqn/Wjo='
WHERE
key_id = '542ce9878d0765fb37fc697a8cf62fb7934699820829c90e9907b8bfcd9c169f'
AND (
token = 'lWRnOd7STlgDtFTjAB82PgOQdz8fdSwoefm2xqn/Wjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)