UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NmHvVWM7LAorvUFhzlM4AKOH9eSlNOD2cXZ0XCT3Y/U='
WHERE
key_id = 'd612f5f0b975a4330025df52d2ed8c4288136f8b34293a93f77c21cb642be3d8'
AND (
token = 'NmHvVWM7LAorvUFhzlM4AKOH9eSlNOD2cXZ0XCT3Y/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)