UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXnapYie2Oh6oVxBOKtaGoW1tK2LDzXrObzts5f7zBQ='
WHERE
key_id = '7f75daa2305d10c4fe372de2a5e07331a7d63123af7050a8ad0386f8ab8f0189'
AND (
token = 'PXnapYie2Oh6oVxBOKtaGoW1tK2LDzXrObzts5f7zBQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)