UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZ4yzBXIE6o0CUgT+ygBz2cIBNdMxSxZM4gx1g6Pg7E='
WHERE
key_id = 'f32a283509f1986bf769d0b0b85bd880eb2264088001267b54d6535f978c76c3'
AND (
token = 'XZ4yzBXIE6o0CUgT+ygBz2cIBNdMxSxZM4gx1g6Pg7E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)