UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+9deDdy+r5dbEK0sypJpWqJTVvNE4CILEz/bKZevp/E='
WHERE
key_id = 'dae2f7430ef59f78b764bc08c0d96864078a7a45082068fb095d2bf3f98f14ee'
AND (
token = '+9deDdy+r5dbEK0sypJpWqJTVvNE4CILEz/bKZevp/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)