UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3+hL6tNuXz6NCjcBjEYkIODGZ/frN9zvhqLiSd5khrs='
WHERE
key_id = 'd53c60c4d27c4872334c7e5d88704fdc5b9198d0c1e0398e18d31c940b3a7243'
AND (
token = '3+hL6tNuXz6NCjcBjEYkIODGZ/frN9zvhqLiSd5khrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)