UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CCNmA45Jfuvx9/lIgn/aDg8lKybQ0zpGPey04JIwRdw='
WHERE
key_id = 'e0601cb4d0a4733ca89ae524a56782bac5d75f2d48a7e044804dd8bf717b25e8'
AND (
token = 'CCNmA45Jfuvx9/lIgn/aDg8lKybQ0zpGPey04JIwRdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)