UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PiBmBUdFd+19zJEUgDksMPC8zF1Zw8XI+JY+kS2RNXo='
WHERE
key_id = '0314adb798c4bb73f33bc7e57622964d935b587b050d44baef814609f35a3962'
AND (
token = 'PiBmBUdFd+19zJEUgDksMPC8zF1Zw8XI+JY+kS2RNXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)