UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KJSS6abxdxHlJfdR8U9FIfEQ/R1nuEK7sZHY+UkUCJw='
WHERE
key_id = '5f0516a5eebed3629c2f2512c001c35340afb6487a5bf5d3797ee529796b7924'
AND (
token = 'KJSS6abxdxHlJfdR8U9FIfEQ/R1nuEK7sZHY+UkUCJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)