UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yPHVI0yVq49muTf5cNHdf5KiUtzcs1jMz3JywoPP8KM='
WHERE
key_id = 'c2041bfd9582fc50376ea3d4e31d7b1f94c0ce88767e0c431f293a1fb23f316c'
AND (
token = 'yPHVI0yVq49muTf5cNHdf5KiUtzcs1jMz3JywoPP8KM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)