UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aCHq9Ya9DjpJ3G+Di4AWzoVkvSZabd8olWgBN+OCH1I='
WHERE
key_id = 'fd741240e631b296f2c36d51a5a4fb062518ee127345398cdde37f679c787caa'
AND (
token = 'aCHq9Ya9DjpJ3G+Di4AWzoVkvSZabd8olWgBN+OCH1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)