UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7UQ2SBDMi8Jc4tZyyPm0TSggIRC5MZTy5F23+OMJnwY='
WHERE
key_id = '30ddeefeb9c97a27cc6767db9b5744196ff227ec3b326debd798d385c9bebd69'
AND (
token = '7UQ2SBDMi8Jc4tZyyPm0TSggIRC5MZTy5F23+OMJnwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)