UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+LxsCAJLBvHnLBqxhI342/rq34a3DjRANSNe17Uvheg='
WHERE
key_id = '5786d2b6e9bf4c316607ed9b689043856c8fbe4e8facf1d57e4558b8fb770fff'
AND (
token = '+LxsCAJLBvHnLBqxhI342/rq34a3DjRANSNe17Uvheg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)