UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i0FsqTmQ5FH0W4roP8nm2454gxquz8V/DXVRJ3NGL/w='
WHERE
key_id = 'b3ee9766a1b97b0190a0ad4cfc2974ff63d3915f5fca574a09a39e049eebe939'
AND (
token = 'i0FsqTmQ5FH0W4roP8nm2454gxquz8V/DXVRJ3NGL/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)