UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pjV4fk+cu1m/zBBy9EtpZfiUWA9j4ukzl2y1Ol1PB10='
WHERE
key_id = 'ff1b922f0b44c3efb3cf9e2b381f89924c1792762cd8b8eaaf7e75e35193fb3f'
AND (
token = 'pjV4fk+cu1m/zBBy9EtpZfiUWA9j4ukzl2y1Ol1PB10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)