UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZrYC7/HRi8fSZsjhZe4vwAAx9TguOUJl9gFXs7WWOyE='
WHERE
key_id = '70e5be42e7874f7f6013fad2bb9a3c7a49bed83c72ce4212ad5c11053ea0843f'
AND (
token = 'ZrYC7/HRi8fSZsjhZe4vwAAx9TguOUJl9gFXs7WWOyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)