UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QKifGuHi2kMZa4MFH30mgIlpe0hMj3HS1zaW+gG0m+Y='
WHERE
key_id = 'ded6209d67951c8d6d76889deb7af9333a9e728ab365f173a903260f54e4aa92'
AND (
token = 'QKifGuHi2kMZa4MFH30mgIlpe0hMj3HS1zaW+gG0m+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)