UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VS96/szk7ke1v1hH0/JYm7kYrbAE8MgUTEZ0nMiJli4='
WHERE
key_id = '6c9d47b10f36615374afc691fc4c5045c47c565a38448947ac3df6b7943a4650'
AND (
token = 'VS96/szk7ke1v1hH0/JYm7kYrbAE8MgUTEZ0nMiJli4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)