UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YI6vRFxDTB2fiE4Kit+cyPEoc/5JyeCuG6IK/rtBkOc='
WHERE
key_id = 'fedf622b25b3f71f594fb1270a0079c089e4d319038c900e8fc232f27096704a'
AND (
token = 'YI6vRFxDTB2fiE4Kit+cyPEoc/5JyeCuG6IK/rtBkOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)