UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tDMV9ugGrox1dzJ3V+X1f0pIdNS/T8vXqNi15M06hCY='
WHERE
key_id = 'e475208bacd455ef44ea76cebd8265ffec078a1b14f64caf55c2d9b5f79a7cd7'
AND (
token = 'tDMV9ugGrox1dzJ3V+X1f0pIdNS/T8vXqNi15M06hCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)