UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5TstDD4qPV+U1a9fHPI7Ko9ii1ugvPJG+wh3M7VbpwU='
WHERE
key_id = '4f47156524335a3053d0195459efe072f4587ea4c942c185f1f156bf66e7fea5'
AND (
token = '5TstDD4qPV+U1a9fHPI7Ko9ii1ugvPJG+wh3M7VbpwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)