UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQuIpnFAo5Boida+Ofgf96RmRi1jGWVxhxY0otSnRyE='
WHERE
key_id = '565cbbce74c56b255581dc29e443a311043c792144f804373c459b0efa7a2278'
AND (
token = 'ZQuIpnFAo5Boida+Ofgf96RmRi1jGWVxhxY0otSnRyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)