UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SbzJ4VpMrGvIO2Yqgroz9k1PFG6HaeD7f73JomZ7wdk='
WHERE
key_id = '4b3e6b0286accb184f8360b28d7df34c5f8178a8f3b06323f972396632aa5405'
AND (
token = 'SbzJ4VpMrGvIO2Yqgroz9k1PFG6HaeD7f73JomZ7wdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)