UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KBDmaf9+GYNn69ZHIuW1L9bcQwGCZ+OCQ9Al+66hhz4='
WHERE
key_id = '0b9e9039f155e2f0be27d5285dbefe9b395ae67fa58e72e0d3c602b12a6c687f'
AND (
token = 'KBDmaf9+GYNn69ZHIuW1L9bcQwGCZ+OCQ9Al+66hhz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)