UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3QfJluECC/ovBG8UMPwfdC4oL69bx3ZADDeRvIu0Yn4='
WHERE
key_id = '8bdfe5a410e9dea7a0dc3561b50045903feae53aacdf50d87870994c28cc76bc'
AND (
token = '3QfJluECC/ovBG8UMPwfdC4oL69bx3ZADDeRvIu0Yn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)