UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcQWmf+tN6q4vWGRMKrDVlOL6BZXD/gdr45zrQLp6HU='
WHERE
key_id = '78e315012f1ca5377b44f61b54502b48dcfa1874fa996f020408878880303421'
AND (
token = 'zcQWmf+tN6q4vWGRMKrDVlOL6BZXD/gdr45zrQLp6HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)