UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Rx0r3j1wQYpwxFnfSnn0AUGC6jHK/BZjkSJWipYKgk='
WHERE
key_id = 'bc09050df075d01b2b12fc218f406c79f2b9f14054c03344407cd521290bfdf0'
AND (
token = '8Rx0r3j1wQYpwxFnfSnn0AUGC6jHK/BZjkSJWipYKgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)