UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DBsU7vauqnO5ZoPsvjIcZRzVi8O6b1JiTCuSt89r0cE='
WHERE
key_id = 'e90a5b077954c5f035160ac1f59a69d71440b35650136508487019d42bf419c4'
AND (
token = 'DBsU7vauqnO5ZoPsvjIcZRzVi8O6b1JiTCuSt89r0cE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)