UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJ/CzXTUcQUkkzxvd9y4I+OCNdJ0tNcKgENXHbxh0MA='
WHERE
key_id = '9b43758b967380730836d245f77427fc32e5d6e0faac7c0b42590046b98ea4ac'
AND (
token = 'zJ/CzXTUcQUkkzxvd9y4I+OCNdJ0tNcKgENXHbxh0MA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)